﻿<?xml version="1.0" encoding="utf-8"?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobj of eComDeliveryInfo">
	<Sql>
		SELECT 
			od.id ,pickupDate,calculatedDate,trackingNumber,deliveryMethodName, shippingTotal, handlingTotal,
			deliveryProviderId as provider_id, dp.name as provider_name
		FROM 
			eComOrderDeliveries AS od
			JOIN eComDeliveryProviders AS dp ON od.deliveryProviderId = dp.id
		WHERE 
			orderId = @orderId
	</Sql>
	<Param name="orderId" type="UniqueIdentifier"/>
</AdoNetDataAccess>
